<?php include("langsettings.php"); ?>
<html>
	<head>
		<meta name="author" content="Kai Oswald Seidler">
		<link href="xampp.css" rel="stylesheet" type="text/css">
		<title></title>
	</head>

	<body>
		&nbsp;<p>

		<h1><?=$TEXT['phonebook-head']?></h1>

		<?=$TEXT['phonebook-text1']?><p>
		<?=$TEXT['phonebook-text2']?><p>

		<?php
			// Copyright (C) 2003 Kai Seidler <oswald@apachefriends.org>
			//
			// This program is free software; you can redistribute it and/or modify
			// it under the terms of the GNU General Public License as published by
			// the Free Software Foundation; either version 2 of the License, or
			// (at your option) any later version.
			//
			// This program is distributed in the hope that it will be useful,
			// but WITHOUT ANY WARRANTY; without even the implied warranty of
			// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
			// GNU General Public License for more details.
			//
			// You should have received a copy of the GNU General Public License
			// along with this program; if not, write to the Free Software
			// Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

			if (!($db = sqlite_open('sqlite/phonebook', '0666'))) {
				echo "<h2>".$TEXT['phonebook-error']."</h2>";
				die;
			}
		?>

		<h2><?php echo $TEXT['phonebook-head1']; ?></h2>

		<table border="0" cellpadding="0" cellspacing="0">
			<tr bgcolor="#f87820">
				<td><img src="img/blank.gif" alt="" width="10" height="25"></td>
				<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib1']; ?></b></td>
				<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib2']; ?></b></td>
				<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib3']; ?></b></td>
				<td class="tabhead"><img src="img/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['phonebook-attrib4']; ?></b></td>
				<td><img src="img/blank.gif" alt="" width="10" height="25"></td>
			</tr>

			<?php
				$firstname=$_REQUEST['firstname'];
				$lastname=$_REQUEST['lastname'];
				$phone=$_REQUEST['phone'];

				if($firstname!="")
				{
						sqlite_query($db,"INSERT INTO users (firstname,lastname,phone) VALUES('$firstname','$lastname','$phone')");
				}

				if($_REQUEST['action']=="del")
				{
						sqlite_query($db,"DELETE FROM users WHERE id={$_REQUEST['id']};");
				}

				$result=sqlite_query($db,"SELECT id,firstname,lastname,phone FROM users ORDER BY lastname;");

				$i = 0;
				while ($row = sqlite_fetch_array($result)) {
					if ($i > 0) {
						echo "<tr valign='bottom'>";
						echo "<td bgcolor='#ffffff' height='1' style='background-image:url(img/strichel.gif)' colspan='6'></td>";
						echo "</tr>";
					}
					echo "<tr valign='middle'>";
					echo "<td class='tabval'><img src='img/blank.gif' alt='' width='10' height='20'></td>";
					echo "<td class='tabval'><b>".$row['lastname']."</b></td>";
					echo "<td class='tabval'>".$row['firstname']."&nbsp;</td>";
					echo "<td class='tabval'>".$row['phone']."&nbsp;</td>";

					echo "<td class='tabval'><a onclick=\"return confirm('".$TEXT['phonebook-sure']."');\" href='phonebook.php?action=del&amp;id=".$row['id']."'><span class='red'>[".$TEXT['phonebook-button1']."]</span></a></td>";
					echo "<td class='tabval'></td>";
					echo "</tr>";
					$i++;
				}

				echo "<tr valign='bottom'>";
				echo "<td bgcolor='#fb7922' colspan='6'><img src='img/blank.gif' alt='' width='1' height='8'></td>";
				echo "</tr>";

				sqlite_close($db);
			?>

		</table>

<h2><?=$TEXT['phonebook-head2']?></h2>

<form action=phonebook.php method=get>
<table border=0 cellpadding=0 cellspacing=0>
<tr><td><?=$TEXT['phonebook-attrib1']?>:</td><td><input type=text size=20 name=lastname></td></tr>
<tr><td><?=$TEXT['phonebook-attrib2']?>:</td><td> <input type=text size=20 name=firstname></td></tr>
<tr><td><?=$TEXT['phonebook-attrib3']?>:</td><td> <input type=text size=20 name=phone></td></tr>
<tr><td></td><td><input type=submit border=0 value="<?=$TEXT['phonebook-button2']?>"></td></tr>
</table>
</form>
	    <?php include("showcode.php"); ?>
	</body>
</html>
